Learn more
About using If( )Then( )Else( ) in a calculated field
About operators
Operators are symbols that represent a type of mathematical or relational process to carry out in an expression. You can select from the following operators:
|
Operator |
Description |
|---|---|
|
+ |
Addition |
|
– |
Subtraction |
|
* |
Multiplication |
|
/ |
Division |
|
= |
Equal to |
|
< > |
Not equal to |
|
( ) |
Open/close parenthesis. |
|
< |
Less than |
|
> |
Greater than |
|
<= |
Less than or equal to |
|
>= |
Greater than or equal to |
|
& |
Ampersand |
|
If( )Then( )Else( ) |
Tests for a condition. |
|
{S} |
Inserts a find and replace field for an alphanumeric variable. |
|
{N} |
Inserts a find and replace field for a numeric variable. |
|
{D} |
Inserts a find and replace field for a date variable. |
|
SQL Queries |
Tests for a condition. |